Previous Thread
Next Thread
Print Thread
Rate Thread
#221770 07/28/2002 2:34 AM
Joined: Nov 2001
Posts: 10,369
I type Like navaho
I type Like navaho
Joined: Nov 2001
Posts: 10,369
We're always struggling to get our users to fill in their profiles. It would be cool, if an Icon would appear below their pic (next to their posts) *IF* they have a completed profile (ie. not empty).

I don't have a clue of how to acomplish that.... but so many users complain of clicking on someone's username, only to see a totally empty profile.

Sponsored Links
Joined: Feb 2002
Posts: 1,759
Addict
Addict
Offline
Joined: Feb 2002
Posts: 1,759
Hey, that's a pretty neat idea. I know more than half of my users never fill out their profile, and its kind of annoying being it is a somewhat regional site and at least a name/location would be nice because you may know the person and not even know it.

On the same note, i don't remember but can you specify certain fields to be required when they sign up? I know that doesn't help existing users, but it would be nice to have.

Joined: Jun 2001
Posts: 3,273
That 70's Guy
That 70's Guy
Offline
Joined: Jun 2001
Posts: 3,273
Perhaps one could modify the editbasic/changebasic scripts to issue stars to the users when they provide various information in their profile.

This would work for those that have the user ratings feature removed from thier setup only, though.

One star could be assigned for 5 different fields and be awarded when filled in. A 5 star user would have more information filled in than a 1 star user.

The code changes to editbasic/changebasic would not be to involved to accomplish this. One would also want to set everyone to 0 just in case there are any old ratings stored.


If you want I'll put the code together later tonight for this mod. It's an easy one.

Joined: Nov 2001
Posts: 10,369
I type Like navaho
I type Like navaho
Joined: Nov 2001
Posts: 10,369
That would be AWESOME!!!

We're not using the user ratings anyway!
Thanks Dave!

Joined: Feb 2002
Posts: 1,759
Addict
Addict
Offline
Joined: Feb 2002
Posts: 1,759
I like that idea as well. We are currently using the rating system, but as of late a few people who have too much time on their hands have been going rating crazy, and I doubt its really adding anything useful to the forums anyway.

Sponsored Links
Joined: Nov 2001
Posts: 10,369
I type Like navaho
I type Like navaho
Joined: Nov 2001
Posts: 10,369
What would be the SQL command to set all the user ratings to 0. Does anyone know?

Joined: Jun 2001
Posts: 3,273
That 70's Guy
That 70's Guy
Offline
Joined: Jun 2001
Posts: 3,273
UPDATE w3t_Users
SET U_Rating = '0', U_Rates = '0'
WHERE 1



That should work.

Joined: Jun 2001
Posts: 3,273
That 70's Guy
That 70's Guy
Offline
Joined: Jun 2001
Posts: 3,273
In your changebasic.php script paste this:

code:

// ====== START =======
// Profile Star Rewards
$stars = 0;
if (!empty($Fakeemail)) {
$stars = $stars + 5;
}
if (!empty($Name)) {
$stars = $stars + 5;
}
if (!empty($Occupation)) {
$stars = $stars + 5;
}
if (!empty($Hobbies)) {
$stars = $stars + 5;
}
if (!empty($Location)) {
$stars = $stars + 5;
}
if (!empty($Bio)) {
$stars = $stars + 5;
}
if (!empty($Picture)) {
$stars = $stars + 5;
}
if ($Visible == "yes") {
$stars = $stars + 5;
}
$realrating = $stars / 8;
$realrating = intval($realrating);
$stars_q = addslashes($stars);
$realrating_q = addslashes($realrating);
$query = "
UPDATE w3t_Users
SET U_Rating = '$stars_q',
U_Rates = '8',
U_RealRating = '$realrating_q'
WHERE U_Username = '$Username_q'
";
$dbh -> do_query($query);
// Profile Star Rewards
// ======= END ========




Just above this line:

code:

// ---------------------------------------------------
// Send them to their start page with the confirmation
$html -> start_page($Cat);






I think that should do the trick.



Last edited by JustDave; 07/28/2002 5:55 PM.
Joined: Jun 2001
Posts: 3,273
That 70's Guy
That 70's Guy
Offline
Joined: Jun 2001
Posts: 3,273
You may want to add something stating which fields add star points in the editbasic.php display. One could add other fields easily to this hack but I kept it to what I thought was the basics.

Joined: Feb 2002
Posts: 1,759
Addict
Addict
Offline
Joined: Feb 2002
Posts: 1,759
Dave, you never cease to amaze me Looks great, I will test it out tonight and see how many people are up in arms when their 5 stars drop down to 0 or 1

Sponsored Links
Joined: Jun 2001
Posts: 3,273
That 70's Guy
That 70's Guy
Offline
Joined: Jun 2001
Posts: 3,273
hehehe yeah I would love to be able to hear what some would be saying to their screens... LoL

Personally I think this is one of the better uses for the user ratings. The user has control of their rating and they can only blame themselves for a low one. LoL

Joined: Jun 2002
Posts: 375
Enthusiast
Enthusiast
Offline
Joined: Jun 2002
Posts: 375
Hmm, now this seems like a good use for user rating stars I turned mine off and left the post ones on, but I may try this out after I think it over. Nice job

Joined: Nov 2001
Posts: 10,369
I type Like navaho
I type Like navaho
Joined: Nov 2001
Posts: 10,369
OK - Cool!

Thanks Dave. You're awesome!
Just playing with this on a test board I've got set up. I dont' think it's quite working right.

First, the SQL statement seems to wipe the stars out of the profile... but they remain next to people's post. Not a huge deal.... only like 10 -15 users were rated before I removed the feature.

Then, I inserted the code. Now obviously, one needs to edit their profile for this info to update. OK. Did that with a test user, filled in all the fields. That worked. Look at their profile, and indeed, they had 5 stars with 8 rates (they were 0 before) OK.
But, then when I made a post by that user... the stars did not appear next to the post. The only stars that appeared next to the post were the few users who had ratings to begin with.
So somehow it's not pulling it into showflat/showthreaded. But does seem to be adding the ratings when you view their profile.

Thanks for looking at this Dave!!!

Joined: Jun 2001
Posts: 3,273
That 70's Guy
That 70's Guy
Offline
Joined: Jun 2001
Posts: 3,273
I think that it there may be some check in showflat/showthreaded that makes sure the rates are real. There is no "0" rating in the real system but with this hack it essentially gives zeros for fields that are not filled out.

I'll look things over and get right back.

Joined: Jun 2001
Posts: 3,273
That 70's Guy
That 70's Guy
Offline
Joined: Jun 2001
Posts: 3,273
Ok I found the error on my part. I'll edit the code I posted to include the correction.

Joined: Jun 2001
Posts: 3,273
That 70's Guy
That 70's Guy
Offline
Joined: Jun 2001
Posts: 3,273
Should work now.

I have edited the posted code above.

Joined: Nov 2001
Posts: 10,369
I type Like navaho
I type Like navaho
Joined: Nov 2001
Posts: 10,369
[:"red"] AWESOME!!!![/]

THANKS DAVE!!!

Joined: Nov 2001
Posts: 10,369
I type Like navaho
I type Like navaho
Joined: Nov 2001
Posts: 10,369
Forgot to say.....

Works Perfect!!!!!

Thanks again!

Joined: Jun 2001
Posts: 3,273
That 70's Guy
That 70's Guy
Offline
Joined: Jun 2001
Posts: 3,273
Your welcome (was an easy one)

Joined: Nov 2001
Posts: 10,369
I type Like navaho
I type Like navaho
Joined: Nov 2001
Posts: 10,369
Ha. Easy for you of course.

Now, this may be more difficult, but now that stars indicate how complete the profiles are.....
What if the stars were added to the user list, and you could sort by stars. Thus someone could view the userlist, and put all the profiles in order by completeness.

My gut said to change the template for the userlist... but I guess there's no rating query in place, so it wouldn't work.

Don't know how difficult that would be. Then to have the ability to sort by stars. LOL It's over my head.

Joined: Jun 2001
Posts: 3,273
That 70's Guy
That 70's Guy
Offline
Joined: Jun 2001
Posts: 3,273
That shouldn't be to hard of a hack either. I'll see what I can do.

Joined: Nov 2001
Posts: 10,369
I type Like navaho
I type Like navaho
Joined: Nov 2001
Posts: 10,369
This has been working VERY well for me at my site. My users just LOVE it!!!!
Thanks Dave!

I made some tweaks to the interface... like instead of it popping up saying "8 total rates" it now will say "5 stars mean a complete profile" etc...

Since Dave is busy working on 5.0 of the Integrated Index Pal, I wrote this up...with my interface tweaks and posted in the Beta forum.

I'm going to look at trying to add the stars into the userlist... not sure if that's over my head or not. Might still need help with that, especially with the ability to sort by stars... but I'm going to give it a college try, and if I get it, I'll post an update.

Thanks again!


EDIT: I've actually surprised myself and am making good progress with this. Right now it's only giving me the "rating" in numerical form. But I've even figured out the sort thing. Once I get it converted to show the stars, this will be good to go!

Last edited by JoshPet; 08/05/2002 7:24 PM.
Joined: Jun 2001
Posts: 3,273
That 70's Guy
That 70's Guy
Offline
Joined: Jun 2001
Posts: 3,273
Your welcome Josh


I have attached the information on modifying showmembers.php to accomodate your searching/sorting. Let me know if it works.




I can't seem to delete this post...

The instructions attached need fixing.
Attachments

Last edited by JustDave; 08/05/2002 8:13 PM.
Joined: Nov 2001
Posts: 10,369
I type Like navaho
I type Like navaho
Joined: Nov 2001
Posts: 10,369
Wow Dave, you're awesome! And faster than me.

I actually was pretty proud of myself... I figured it out 95% of the way. It was sorta working... except I had one user...without stars that was appearing with all the other 5 star people.

But in looking at your instructions... you used:

U_RealRating ASC
U_RealRating DESC

and I was using
U_Rating ASC
U_Rating DESC

which must have been getting slightly different results.

I'll update the directions to your hack.... and repost.

Thanks as always for your help!

Joined: Jun 2001
Posts: 3,273
That 70's Guy
That 70's Guy
Offline
Joined: Jun 2001
Posts: 3,273
Ack.. yeah that was an error. I had fixed other sections that was using the U_RealRating but forgot about that one.

Sorry

I'm glad you got it working though.

Joined: Nov 2001
Posts: 10,369
I type Like navaho
I type Like navaho
Joined: Nov 2001
Posts: 10,369
No YOU had it right (of course).

I had U_Rating which wasn't quite working correctly. But then again, I don't really know what I'm doing. LOL


Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Shock Hosting
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
isaac
isaac
California
Posts: 1,153
Joined: July 2001
Forum Statistics
Forums63
Topics37,583
Posts293,955
Members13,824
Most Online151,614
Nov 14th, 2025
Today's Statistics
Currently Online 520
Topics Created 0
Posts Made 0
Users Online 0
Birthdays 24
Top Posters
AllenAyres 21,080
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,834
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2026 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.1.0
(Snapshot build 20260108)